{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Documentation","Loan Data","Loan Calculator"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Documentation","index":0,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["First National Bank New Loan Report"]
[]
["Author","Akaria Babbs"]
["Date","2016-01-15"]
["Purpose","Monthly \"New Loan Report\" for the Board of Directors to list and summarize all new loans for residential housing in the past month."]

{"sheet":"Loan Data","index":1,"n_rows":27,"n_cols":7,"rows_kept":27,"cut":false,"hidden":false,"merged":[[20,1,20,2],[0,0,0,6]]}
["First National Bank - New Loans"]
[]
["Customer","Selling Price","Loan Term","Interest Rate","Down Payment","Amount to be Financed","Monthly Payment"]
["Allen",265354,30,{"$f":"VLOOKUP(C4,$A$17:$B$20,2,FALSE)","v":6.25E-2},{"$f":"VLOOKUP(C4,$A$17:$C$20,3,FALSE)*B4","v":66338.5},{"$f":"B4-E4","v":199015.5},{"$f":"PMT(D4/12,C4*12,-F4,,1)","v":1219.0235838487067}]
["Arnold",328788,15,{"$f":"VLOOKUP(C5,$A$17:$B$20,2,FALSE)","v":5.7500000000000002E-2},{"$f":"VLOOKUP(C5,$A$17:$C$20,3,FALSE)*B5","v":49318.2},{"$f":"B5-E5","v":279469.8},{"$f":"PMT(D5/12,C5*12,-F5,,1)","v":2309.6782013256675}]
["Barber",500000,15,5.7500000000000002E-2,75000,425000,3512.4125596519148]
["Bollis",112485,30,6.25E-2,28121.25,84363.75,516.75070972821879]
["George",350000,30,6.25E-2,87500,262500,1607.8832591445669]
["Hood",761978,20,0.06,152395.6,609582.4,4345.5100901657715]
["Morgan",192940,15,5.7500000000000002E-2,28941,163999,1355.3697585184807]
["Paul",606563,20,0.06,121312.6,485250.4,3459.1886338204267]
["Pinder",319765,30,6.25E-2,79941.25,239823.75,1468.9851153153209]
[]
[]
[]
[]
["Loan Term","Interest Rate","% Required for Down Payment"]
[15,5.7500000000000002E-2,0.15]
[20,0.06,0.2]
[30,6.25E-2,0.25]
[null,"Loan Statistics"]
[null,"Number of Loans",{"$f":"COUNTIF(G4:G12,\">0\")","v":9}]
[null,"Highest Amount Financed",{"$f":"MAX(F4:F12)","v":609582.4}]
[null,"Lowest Amount Financed",{"$f":"MIN(F4:F12)","v":84363.75}]
[null,"Total Amount Financed",{"$f":"SUM(F4:F12)","v":2749004.6}]
[]
["Todays Date",{"$f":"TODAY()","v":"2016-01-15"}]

{"sheet":"Loan Calculator","index":2,"n_rows":6,"n_cols":9,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["Interactive Loan Calculator"]
["Please provide the following information:",null,null,"Based on the information you have provided, your loan option are:"]
["What is the price of the home?",125000,null,"Years of Loan","Interest","Down Payment","Monthly Mortgage Payment"]
["Do you wish to put any additional money down?",null,null,15,5.7500000000000002E-2,{"$f":"B3*0.15","v":18750},{"$f":"PMT(E4/12,D4*12,-($B$3-F4-$B$4),,IF($B$5=\"Yes\",1,0))","v":882.31071745839506},null,"Yes"]
["Pay at the beginning of month?","No",null,20,0.06,{"$f":"B3*0.2","v":25000},{"$f":"PMT(E5/12,D5*12,-($B$3-F5-$B$4),,IF($B$5=\"Yes\",1,0))","v":716.4310584781648},null,"No"]
[null,null,null,30,6.25E-2,{"$f":"B3*0.25","v":31250},577.23487539974212]